In Base SAS^®, several issues might occur if your SQL procedure query consists of all of the following:

• A LIBNAME engine used to access a DBMS table
• A join of two tables, one being a SAS table and the other a DBMS table
• The MULTI_DATASRC_OPT=IN_CLAUSE option specified in the LIBNAME statement
• Two join conditions in the WHERE clause, where one is a match of a numeric variable in each table and the second an IN clause of another variable
• A row in the SAS table and a missing join variable

You might see any or all of these issues:

• A syntax error returned from the DBMS due to a missing operator before the condition being added to test for a null
• An incorrect variable being referenced in the test for the null
• An incorrect variable being referenced in the IN clause built for the join condition

Currently there is no workaround.

A fix is planned for a future software release.

Operating System and Release Information